Access Level 2

Students will learn how to enhance database designs.

Lesson 1: Relational databases
Database normalization
Table relationships
Referential integrity
Lesson 2: Related tables
Creating lookup fields
Modifying lookup fields
Subdatasheets
Lesson 3: Complex queries
Joining tables in queries
Using calculated fields
Summarizing and grouping values
Lesson 4: Advanced form design
Adding unbound controls
Graphics
Adding calculated values
Adding combo boxes
Advanced form types
Lesson 5: Reports and printing
Report formatting
Calculated values and subreports
Printing
Label printing
Lesson 6: Charts
Charts in forms
Charts in reports
Lesson 7: PivotTables and PivotCharts
PivotTables
Modifying PivotTables
PivotCharts
PivotTable forms

Printable course details

or equivalent knowledge.

7.5 hours

Individual Tuition

Group Training

Distance Learning

Prices

Distance Learning price